UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UPbz7UlCTIKeeBog5oSlB6cEVmBpLXGxkigkA7D3Xbw='
WHERE
key_id = '274e90c8f146807e0ffc46f26eec56c9494ddebf80cc51af88a32dc4d02dce7d'
AND (
token = 'UPbz7UlCTIKeeBog5oSlB6cEVmBpLXGxkigkA7D3Xbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)