UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'atMaEK9ztJ6f0AVTppvw2yB9q+tNCOw+puOu5LYqxs0='
WHERE
key_id = '0a6cf526fad4c48adc6067cf471aadc835aa810abeb8337dd05a24bac134c07d'
AND (
token = 'atMaEK9ztJ6f0AVTppvw2yB9q+tNCOw+puOu5LYqxs0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)