UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z6Sul9G75yhULrA4Mp3gd4BkKA0pUaVvozElKzvtNYs='
WHERE
key_id = 'e127306bdc15e476a30ac78677d588c422900db2220d5266f9b8a4d8b16e0cec'
AND (
token = 'z6Sul9G75yhULrA4Mp3gd4BkKA0pUaVvozElKzvtNYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)