UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oaUcs8ch7i4oyCS8hQEUTz5XIptFzsM1QWkZtHiFVk8='
WHERE
key_id = '733a59dca01df763b2f070310fb7e3fbe5066ebc107fc7eb7e1c85af0a886d3a'
AND (
token = 'oaUcs8ch7i4oyCS8hQEUTz5XIptFzsM1QWkZtHiFVk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)