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