UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xGo3PoDH+fmQq2qr0jcaj8xtuzG2NHL+OI05csVeWas='
WHERE
key_id = 'ddf54f21b2b1ff0711ff6d7f65a4dc81236e180e10e8306b0b020fc82d92e7e1'
AND (
token = 'xGo3PoDH+fmQq2qr0jcaj8xtuzG2NHL+OI05csVeWas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)