UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xKmdYnmwy2pfTBk39KaiDqzrnI5ioE4DrSmqH6wl3A='
WHERE
key_id = 'e1fd37b94305a585accf1850d893280533c61cf1d95ce531f1df5e9a637b5f87'
AND (
token = '0xKmdYnmwy2pfTBk39KaiDqzrnI5ioE4DrSmqH6wl3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)