UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXbEaYQUMZuPrl9dGdyQVSDd6299GXn17wCAutoTgUQ='
WHERE
key_id = '709e99788f3aeca6bfe7fd72c3124ac87cf661db58ccb4e12658394fee73f14a'
AND (
token = 'gXbEaYQUMZuPrl9dGdyQVSDd6299GXn17wCAutoTgUQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)