UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'soXPKcnkhmHTlr4tiBWBapFd0JmKB2d2Im/LkZogmHQ='
WHERE
key_id = 'c1d58524d54b79de5b8c10e35c9e8ba02c3729827c7df0c482376bb6332b19f3'
AND (
token = 'soXPKcnkhmHTlr4tiBWBapFd0JmKB2d2Im/LkZogmHQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)