UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LsoEE2dMTgjDLE4kWSk61T7PkElx9j5DxbGz3DLSwkg='
WHERE
key_id = '9e6d8c871223f5aefe4c9336fea5df89f6f78b155868bc9e3b5901323cf3b4ef'
AND (
token = 'LsoEE2dMTgjDLE4kWSk61T7PkElx9j5DxbGz3DLSwkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)