UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ugi9tvMbfBQ6/kG9uRJ9jcdx3S7ufkCs0R8IKkf0uL4='
WHERE
key_id = '49676a0e80a97230830708914d9c62799d5610ebf38e7522a0c3eb64c474af48'
AND (
token = 'ugi9tvMbfBQ6/kG9uRJ9jcdx3S7ufkCs0R8IKkf0uL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)