UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zB8ZcX2BzVgc7G/HqmNiSxqtK5hl3CJX9vWMns5kBho='
WHERE
key_id = '8928e8bf92c553c757d975831f602bcfd0354e2d30a71bb130721d1cb78dfe9f'
AND (
token = 'zB8ZcX2BzVgc7G/HqmNiSxqtK5hl3CJX9vWMns5kBho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)