UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v1pBkvlQWUd3eiWa4yk56ZNBF9Bf+vuQsV5NSpIKz/Y='
WHERE
key_id = '0eda5723a3c4b90d881a45bf73b4a5b0621cb76e5b2572c38c33629e48ed290f'
AND (
token = 'v1pBkvlQWUd3eiWa4yk56ZNBF9Bf+vuQsV5NSpIKz/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)