UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qnE46Kcq5gg3hQB+aQGKlr3OcYnyxS4j5ElcLdD01Ac='
WHERE
key_id = '3be2aebc249fc9ed74a7bd05fa8f49c7946d289c86a1b3f9d802ad1052be6d7c'
AND (
token = 'qnE46Kcq5gg3hQB+aQGKlr3OcYnyxS4j5ElcLdD01Ac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)