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