UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dfKrj58FTBEFQihYiMJ5B62ylha5k4VFaCWfnnGeUzg='
WHERE
key_id = '01bcd3b0aa2f0af358f68b83eec14e74f10f9afab25217f90e5553454a34d813'
AND (
token = 'dfKrj58FTBEFQihYiMJ5B62ylha5k4VFaCWfnnGeUzg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)