UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0UaYwzAeBbk6cY7jHmnes0MD6aphrHWcHwwkbF9pl8='
WHERE
key_id = 'a6bb247e55d9ae77f35d6c2c8441ccb10d434a30332bd0a5f96f4439b8d52377'
AND (
token = 'X0UaYwzAeBbk6cY7jHmnes0MD6aphrHWcHwwkbF9pl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)