UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QDBuwhBBUmODBdXfHb+SfQxI9jVa+I2yaKYeF2inyzg='
WHERE
key_id = '78987c081459e5911da89a2103d7593d6353b9dfcb84835ac35cac210a69868d'
AND (
token = 'QDBuwhBBUmODBdXfHb+SfQxI9jVa+I2yaKYeF2inyzg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)