UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UnQ0HF20skD3/exvHx33afOCrwnlC8k18NCgRw5AzyA='
WHERE
key_id = 'a8c3e25d131b5d71c9587e89be86918aa5aac77af6acb15ab3fe09241dd574a5'
AND (
token = 'UnQ0HF20skD3/exvHx33afOCrwnlC8k18NCgRw5AzyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)