UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fi8aDp83Ots0Zb24MbTMN1TLDwoxv8W4a9qaX5d5GWA='
WHERE
key_id = 'b848be19c77b78b597dc0cdd94ec83d556bc1bd4deb9ec514294b3c1c8cabc53'
AND (
token = 'fi8aDp83Ots0Zb24MbTMN1TLDwoxv8W4a9qaX5d5GWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)