UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+r7smCnGjYw51Ut7abIIlEf2DvFeIioFkeY28XCfIY8='
WHERE
key_id = 'afbc6db258d342c73e124b2c4145bf5499e19ff3636ae9628aad1fd94ff481a5'
AND (
token = '+r7smCnGjYw51Ut7abIIlEf2DvFeIioFkeY28XCfIY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)