UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h9G7/fRzHxco3ItcEYY64TSMHHKviYwqpwajWXRCeAE='
WHERE
key_id = '789e90b8fd03ff0f9319bd65ef3ea76e0e5ecef1380d31a8f949df2dc4ef0919'
AND (
token = 'h9G7/fRzHxco3ItcEYY64TSMHHKviYwqpwajWXRCeAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)