UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9fg+aSQevAfnJbheukbD68ERH3WYjaIVoAU8rjfYgAU='
WHERE
key_id = '1b68a46598cd55e9573ae91001fbb1f63702648487cbcec71bfc5c9ed61a8680'
AND (
token = '9fg+aSQevAfnJbheukbD68ERH3WYjaIVoAU8rjfYgAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)