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