UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6DxPNoJNEVf+v8J/oRNmDqiEfJTwNyDu/M6w+U6Y7wo='
WHERE
key_id = '3b49774a4b5a3dbce08c61544e5449511d205326f97e8b058cc27dbd1d459645'
AND (
token = '6DxPNoJNEVf+v8J/oRNmDqiEfJTwNyDu/M6w+U6Y7wo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)