UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dCs9YWx3cyldbS4lFshHT5+6hvmelE1st5W2vrq1GJ8='
WHERE
key_id = 'af26352524656e45324cdb374e373acca33758019483093452b1f2217b64a149'
AND (
token = 'dCs9YWx3cyldbS4lFshHT5+6hvmelE1st5W2vrq1GJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)