UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7TNhhw9sN9k1njCWCmgwPEQJkm4LFYE0yMEBxmF4TOA='
WHERE
key_id = '09998f7855874165aefc44d03158e7eea74116928a9909371ccf9f0905e87a7b'
AND (
token = '7TNhhw9sN9k1njCWCmgwPEQJkm4LFYE0yMEBxmF4TOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)