UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UI/8HIgFdHTJz3cX98JFZm4X+hW7r/nxxaUV2QKNieI='
WHERE
key_id = 'ab64575cd28cdd9b7240c29542c82fb4b29bf8c002b540d31181bf810f369547'
AND (
token = 'UI/8HIgFdHTJz3cX98JFZm4X+hW7r/nxxaUV2QKNieI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)