UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZMl/oNw811F61BB30OgWf3RH4HlA/3wiw/FVYEktp74='
WHERE
key_id = 'fde74705c586f9f858be93647744d45ad52bd0c93d5db27eb1b295df411f1a9f'
AND (
token = 'ZMl/oNw811F61BB30OgWf3RH4HlA/3wiw/FVYEktp74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)