UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7BeVoUZLG+UmpHexjaQdvwFu+vxmUSENYd++78WPLtI='
WHERE
key_id = 'b2ec0dd39641d9f5896d4b781c8fba70cdc323fc32b5a745ebdbb30ff20a4f5b'
AND (
token = '7BeVoUZLG+UmpHexjaQdvwFu+vxmUSENYd++78WPLtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)