UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BDrKX5PZjQW0zONN2oVM35tsx8gRwG14erVHtg8mTiU='
WHERE
key_id = '0f58429c197970e51480c41857100b87dcf68243cc8a4a5674c5259b49cc9c22'
AND (
token = 'BDrKX5PZjQW0zONN2oVM35tsx8gRwG14erVHtg8mTiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)