UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8souv/yyqBv5tTQlHWcYdbwAkJejX6FYIw+i0XUr3f0='
WHERE
key_id = 'cd67d3e32d33426a4b7dd2c7eab58048e31252d7cc3297f46ea9628e7c48aaa5'
AND (
token = '8souv/yyqBv5tTQlHWcYdbwAkJejX6FYIw+i0XUr3f0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)