UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mEmZvbaCUbcGcbkIYBEiM4wHBWTcvMpNN6/2NV6L134='
WHERE
key_id = 'a8b653a6491bfc90a543482bd502e39facf6dd16ed0ac262bac818e7edd8416b'
AND (
token = 'mEmZvbaCUbcGcbkIYBEiM4wHBWTcvMpNN6/2NV6L134='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)